--Table--
drop table t_User;
Create Table t_User (
    O_id NUMBER PRIMARY KEY ,
    username VARCHAR(20),
    password VARCHAR(20),
    UserGroup VARCHAR(20),
    constraint pwlength
      check (Length(password) >= 6));

--Sequence--
drop sequence seq_BulichCup;
CREATE SEQUENCE seq_BulichCup
    MINVALUE 1
    MAXVALUE 99999999999999999999
    START WITH 1
    INCREMENT BY 1
    CACHE 20;

--Inserts--
insert into t_User values (seq_BulichCup.NEXTVAL, 'Michael', '123456', 'ADMIN');
insert into t_User values (seq_BulichCup.NEXTVAL, 'Marc', '123456', 'USER');
insert into t_User values (seq_BulichCup.NEXTVAL, 'Andy R.', '123456', 'USER');


